create procedure amsp_CMGetWebsiteNavigation (@WebsiteKey uniqueidentifier) AS
BEGIN
SELECT a.*,
        e.ImageInitial,
        e.ImageOther,
        e.ImageRollover,
        e.BreadCrumb,
        e.ImageWidth,
        e.ImageHeight,
        b.HideFlag AS ParentHideFlag,
        b.PublishedDateTime AS ParentPubValue,
        b.Name AS ParentName,
        c.ShowInTemplateFlag,
        c.OpenInNewWindowFlag,
        c.SecureFlag AS ContentSecureFlag,
        space(255) AS AncestoryList,
        a.HideFlag AS AncestoryHideFlag,
        ' ' AS AncestoryNotPublishedFlag,
        w.WebsiteRootURL,
        w.SecureWebsiteRootURL,
        w.TemplateHeaderFileName,
        w.TemplateFooterFileName,
        w.SiteStyleSheet,
        w.UseHierMenuFlag,
        w.ShowBreadCrumbFlag
    INTO #NavMenu
    FROM Nav_Menu a, Nav_Menu b, Content c, Nav_Menu_Feature e, Website w
   WHERE 1 = 0

  exec amsp_CMNavMenuSetup;

  SELECT TOP 1 * FROM #NavMenu
END

GO
GRANT EXECUTE ON  [dbo].[amsp_CMGetWebsiteNavigation] TO [IMIS]
GO